package com.yager.mapper;

import com.yager.model.House;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface HouseMapper {
    int deleteByPrimaryKey(String houseid);

    String findMaxId();

    int insert(House record);

    int insertSelective(House record);

    House selectByPrimaryKey(String houseid);

    int updateByPrimaryKeySelective(House record);

    int updateByPrimaryKey(House record);

    List<House> selectHouseByConditions( String housetype, String houseaddress, boolean sortage, boolean sortprice);

    List<House> selectHouseByText(String housetext);

    List<House> selectHouseByTextAndConditions(String housetext, String housetype, String houseaddress, int sortage, int sortprice);

    List<House> selectHouseOrderById();

    List<House> selectHouseByUserId(String userid);

    String selectHouseNameById(String houseid);

    void removeCollectionByHouseId(String houseid);

    void removeOrderByHouseId(String houseid);
}